﻿CREATE PROCEDURE [dbo].[sp_public_checkCode]
	@Email nvarchar(100), 
	@Code nchar(10),
	@Total int OUTPUT
AS
	SELECT @Total = COUNT(*) FROM Members WHERE Member_Email = @Email AND Member_Code = @Code
RETURN @Total